Data Architect/engineer

Data Architect

We are seeking a Data Architect for a Banking client. Please note this role will sit onsite 3 days per week in Charlotte, NC.

Further details are below for review.

Client: Banking

Location: Charlotte, NC (3 days onsite per week.)

Length: 12+ month Assignment

Pay Range: $65 - $70/hour W2

We are seeking a highly skilled and detail-oriented ETL & Data Pipeline Specialist with strong analytical capabilities to join our team. The ideal candidate will be responsible for the design and maintenance of robust data pipelines that feed Tableau dashboards and reports to support strategic business decisions. The candidate must possess a deep understanding of data modeling, visualization best practices, and be able to translate complex data into actionable insights. This role ensures data integrity, scalability and alignment with business logic across multiple sources.

Key Responsibilities:

• Design and implement ETL workflows to ingest, transform, and load data from diverse sources (RDBMS, APIs, flat files).
• Build and maintain data models optimized for Tableau consumption.
• Monitor and troubleshoot data pipeline performance and failures.
• Collaborate with BI developers and engineers to align data structures with dashboard needs.
• Implement data quality checks, lineage tracking, and audit logging.
• Collaborate with business analysts and stakeholders to gather reporting requirements and translate them into solutions.
• Analyze large datasets to identify trends, patterns, and key insights that support business objectives.
• Conduct data validation and troubleshooting to ensure data accuracy and integrity.
• Document data sources, logic, and user guides.
• Work closely with front end visualization engineers to ensure seamless data integration.
• Conduct user acceptance testing and provide training/documentation for dashboard consumers.

Required Skills and Qualifications:

• 5+ years of hands-on experience in data engineering and ETL development.
• 3+ years in a large enterprise environment.
• Proficiency in SQL, Python, and ETL tools (e.g., SSIS, Informatica, Talend, Apache NiFi).
• Familiarity with data warehousing concepts and dimensional modeling.
• Strong understanding of data governance and security practices.
• Strong analytical and problem-solving skills with the ability to think critically.
• Experience in troubleshooting and optimizing long-running batch jobs.
• Proficiency in optimizing performance with large datasets.
• Excellent verbal and written communication skills.
• Ability to work independently and manage multiple tasks simultaneously.

Preferred Qualifications:

• Experience with cloud data platforms (e.g., Snowflake, AWS Redshift, Azure Synapse)
• Experience with analytical tools (Tableau, Power BI, etc).
• Experience with Agile development methodologies.
• Ability to convey complex data in a clear and concise manner.
• Proactive and self-motivated with a growth mindset.

Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Apex team member can provide.

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. 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 employeeservices@apexsystems.com or 844-463-6178.