Creating databases optimized for performance, implementing schema changes, and maintaining data architecture standards across BPX databases.
Designing and developing scalable ETL/ELT packages from the business source systems.
Enabling and running data migrations across different databases and different servers.
Responsible for performing thorough testing and validation to support the accuracy of data transformations and data verification.
Ensure proper data governance and quality across the Data Platform development areas.
Performs ad-hoc analyses of data stored in the databases and designs, develops and tests SQL scripts, stored procedures, functions, and views
Troubleshoots data issues within the business and across the business and presents solutions to these issues
Analyze complex data elements and systems, data flow, dependencies, and relationships to contribute to & define conceptual physical and logical data models
Be knowledgeable of industry trends and best practices, advising senior management on new and improved data engineering strategies.
Drive excellent, consistent customer service.
Ensure the proper management, maintenance and provisioning of all environments, databases and related technologies and solutions.
Job requirements
5+ years of relevant work experience in IT/Data & Analytics and data engineering experience
Experience with Azure cloud preferred
Experience with Snowflake, nice to have.
Experience in any big data technologies - Snowflake, Azure Cosmos DB, Azure PaaS/MI, Azure Data Lake, Amazon Redshift, AWS DynamoDB, or advanced analytics tools
Experience with ETL/ELT tools such as Azure Data Factory
Experience with Stonebranch, a plus.
Experience designing and delivering large scale, 24-7, mission-critical data pipelines and features using modern big data architectures
Strong understanding of ETL/ELT processing with large data stores
Strong data modeling skills (relational, dimensional, and flattened)
Strong analytical and SQL skills, with attention to detail
Validated experience with 1 or more non-SQL languages like Python or JavaScript
Ability to work with multiple external teams and accomplish shared goals through the building consensus
Strong communication (written/verbal) and collaboration skills
Consulting, negotiation, and relationship skills
Problem solving skills
Enthusiastic, high-energy individual, self-motivated, people-oriented, and self-directed
Must be able to maintain focus on achieving results, whilst being patient and pragmatic
Desirable criteria & qualifications
Experience with the Azure and/or AWS cloud platforms
Desire to continually learn outside of a classroom environment, and successfully apply learnings
Demonstrated willingness to both teach others and learn new techniques
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 .