Senior Data Architect
Company: Wespath Benefits & Investments
Location: Glenview
Posted on: May 28, 2023
Job Description:
Senior Data Architect
Location:
1901 Chestnut Ave
Glenview, Illinois, 60025
United States Category:
Information TechnologyDate Needed by:
6/5/2023
Primary Duties and Responsibilities: You bring the motivation,
teamwork, and integrity and we'll provide the collaborative
culture, professional development, and respect you deserve. And if
you're good at what you do, you'll have a career at Wespath
Benefits and Investments. Join our team in Information Technology -
and, if you'd like, teams such as our DEI Council, Green Team on
environmental sustainability, or our Change Management team - and
make an impact through your work! Wespath, recognized as a
2017-2022 Chicago's Best and Brightest Companies to Work For and a
2018-2022 National Best and Brightest Companies to Work For, has an
opportunity for a Senior Data Architect that acts as a senior
member of the Application Delivery and Support (ADS) team within IT
and is responsible for the overall design, development, test,
release, maintenance, and technical support of data and reporting
applications to ensure effective data services delivery and support
of enterprise strategies. This person will be key in defining and
executing a business intelligence strategy for Wespath. This role
is also responsible for working with Information Technology (IT)
Infrastructure to ensure server platform and security needs of data
and reporting systems are met. In coordination with project teams
and ADS management, this role will work with the business in
defining project scope, requirements, and timeline for
deliverables. More specifically, as a Senior Data Architect you
will have the opportunity to:
Define and design data architectures
required to deliver reporting and analytics solutionsEnsure
architectures are optimized for performance and scalability, are
secure, sustainable, and easy to supportPerform data modelling and
database design for Wespath data and reporting applications as
neededResponsible for the design, development, test, release,
maintenance, and technical support of custom data applications and
data migration, such as data pipelines, ETL/ELT, data processing,
APIsServe as a liaison between non-technical and information
technology staff to align research goals and infrastructure
requirementsAnalyze and understand business users' requirements,
clarifying inconsistencies, conflicts, or ambiguities, to
effectively develop solutions that meet business needsProvide
technical guidance and innovative thought leadership around
Wespath's solution strategy and approach, including staying up to
date with available technology and toolsAssess existing,
establishes, and adhere to best practices, standards and agreed
upon design patterns for data and reporting application development
and supportExamine and identify database structural necessities by
evaluating current structures, operations, and
applicationsParticipate in design/code reviewsCreate deployment
packages and instructions for releasing data and reporting
applications across environmentsPrepare accurate database design
and architecture reports for management and executive teamsDocument
data and reporting application implementations, configurations, and
support requirements as neededMonitor system performance by
performing regular tests, troubleshooting, and integrating new
featuresEvaluate techniques and design patterns and make
recommendations that will improve new and existing database
systemsEducate staff members through training and individual
supportCorrect reported incidents on data and reporting
applications and release fixes through the change control
processesWork with the DBA to ensure platforms are engineered with
consideration of capacity planning, availability, and performance
of database systems while optimizing the platform costsAs necessary
administer the reporting environment including managing security,
data gateways, and workspacesKnow or is willing to learn DBA
responsibilities to serve as a DBA backupParticipate in the
development and management of governance and frameworks for
managing data across the organizationConducts proof of concepts to
guide technical implementation as neededSenior Data Architect
Benefits:
- Medical, dental, vision and well-being benefits from our
HealthFlex Exchange on day one
- 8% employer contribution to retirement plan with an additional
match up to 2% on day one
- 22 days of PTO + 12 paid holidays Hybrid work environment; able
to work effectively whether in the office or in a remote
location#LI-CW1 #LI-Hybrid
Minimum Requirements/Qualifications:
Bachelor's degree in computer
science, Management Information Systems, or related fieldEight
years of experience in the solution development life cycle for
developing and maintaining data processing and reporting
applicationsExtensive experience with: - System analysis and
design- Data transformation development (ETL/ELT) tools (e.g.,
SSIS, Informatica, DataStage, etc.)- Reporting tools such as Power
BI, Tableau, Domo, Infor Birst, or other similar tools.- Relational
and multi-dimensional data modeling- Performance tuning and
database design for SQL Server- Building Operational Data Stores,
Data Marts, Data Warehouses, Data Lakes, Lake Houses- Working with
non-relational data sources such as flat files, excel files, JSON
files, and APIsPreferred Qualifications
Experience in teaching and mentoring
developers and/or usersExperience or familiarity with:- One or more
Cloud Data platforms- Self-Service Business Intelligence platforms-
Data quality management and master data management- Enterprise
information architecture
Wespath Benefits and Investments is an Equal Opportunity Employer
and does not discriminate in hiring.
Apply NowShare Save Job
Keywords: Wespath Benefits & Investments, Glenview , Senior Data Architect, Other , Glenview, Illinois
Didn't find what you're looking for? Search again!
Loading more jobs...
