Senior Data Architect/Engineer

Job#: 2019866

Job Description:
Senior Data Architect/Engineer
Job Overview
The Commonwealth of Pennsylvania is looking for a Senior Data Architect/Engineer to join its team of analytics professionals to support its Pennsylvania Longitudinal Data System (PALDS) data integration services as well as system deployment and management efforts. The hire will be responsible for implementing and maintaining universal identity and master data management (MDM) solutions, as well as supporting the integration of these solutions into the architecture of an enterprise centralized data hub for the Commonwealth. The ideal candidate has extensive experience designing and building architecture for universal identity and MDM solutions and enjoys optimizing data systems and building them from the ground up. The Senior Data Architect/Engineer will support our application developers, database architects, data analysts, and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects. The Senior Data Architect/Engineer will play a key role in Commonwealth initiatives to master and match records across multiple source systems, enabling a more seamless user experience with Commonwealth services and enhancing an enterprise research program leveraging longitudinal data. They must be self-directed and comfortable supporting the data needs of multiple teams, systems, and products. They must also be comfortable with supporting data conversions associated with system modernization and/or replacement efforts. The right candidate will be excited by the prospect of optimizing the Commonwealth's longitudinal data architecture to support our next generation of data initiatives.
Responsibilities:

• Create and maintain optimal universal identity and MDM architecture.
• Assemble, manage, and ensure the quality of the commonwealth's inventory of unique identities, including both individuals and organizations.
• Manage record de-duplication workflows and process matching cases that require manual resolution.
• Manage data enrichment functions of supported solutions to improve matching capabilities and enhance the value of existing data.
• Manage and maintain connections with RESTful and other third-party APIs.
• Provide technical assistance to the PALDS team with assembling large, complex data sets that meet functional / non-functional business area requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Work with stakeholders including the Executive, Data, Design, and Support teams to assist with data-related technical issues and support their data infrastructure needs.
• Keep data separated and secure across Agency boundaries such as data centers and cloud regions.
• Create data tools for analytics and data scientist team members that assist them in building and optimizing data products needed to support ongoing operations and data-driven decision making.
• Work with data and analytics professionals to strive for greater functionality in our data systems.

Qualifications:

• Experience implementing and maintaining large-scale universal identity solutions, covering millions of unique identities and linking records across multiple source systems.
• Experience implementing and maintaining MDM solutions as part of an enterprise-scale centralized data hub.
• Experience with managing and maintaining connections with third party RESTful APIs.
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Experience building and optimizing 'big data' data pipelines, architectures, and data sets.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Strong analytic skills related to working with unstructured datasets.
• Experience building processes supporting data transformation, data structures, metadata, dependency, and workload management.
• A successful history of manipulating, processing, and extracting value from large, disconnected datasets.
• Working knowledge of message queuing, stream processing, and highly scalable 'big data' data stores.
• Strong project management and organizational skills.
• Experience supporting and working with cross-functional teams in a dynamic environment.
• We are looking for a candidate with 5-7+ years of experience in a Senior Data Architect/Engineer role, who has attained a degree in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field. They should also have experience using the following software/tools:
  • Experience with universal identity and MDM tools: Verato, Tamr, Informatica, Talend, etc.
  • Experience with big data tools: Hadoop, Spark, Kafka, etc.
  • Experience with relational SQL and NoSQL databases, including Oracle, MS SQL Server, Postgres, Cassandra, etc.
  • Experience with data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc.
  • Experience with data integration services solutions from vendors such as Informatica, MuleSoft, Talend, TIBCO, etc.
  • Experience with cloud-based data services such as AWS (EC2, Glue, EMR, RDS, Redshift, etc.) and/or Azure (Azure SQL, Data Factory, Synapse, Databricks, etc.)
  • Experience with stream-processing systems: Kinesis, Storm, Spark-Streaming, etc.
  • Experience with object-oriented/object function scripting languages: Python, R, Java, C++, Scala, etc.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.