Note: The job is a remote job and is open to candidates in USA. ATI | Advanced Technology International is a company focused on simplifying and streamlining research and development processes for new technologies. They are seeking a Data Engineer to design, build, and maintain data infrastructure and pipelines to support analytics and decision-making across the organization.
Responsibilities
- Lead the end-to-end design and development of a data warehouse with external vendor support, including data modeling, ETL pipelines, and integrations from multiple data sources (APIs, databases, etc.)
- Collaborate on the development of a forward-looking data strategy, promoting innovation in data infrastructure and analytics
- Partner with multiple internal stakeholders to understand business challenges & identify opportunities for data driven solutions
- Design, develop, and manage scalable data pipelines and ETL processes to support analytics, reporting, and data science initiatives
- Develop and optimize SQL queries, stored procedures, and database objects to ensure high performance and data consistency
- Build and maintain data integrations from diverse sources including APIs, databases, and flat files, ensuring reliability and data quality
- Support the development of dashboards and BI tools by ensuring the availability of accurate, well-structured data
- Design and implement data validation, monitoring, and alerting systems to proactively identify and resolve data quality issues
- Perform exploratory data analysis and statistical analysis to support business decisions
- Create and maintain processes to generate accurate and timely reports that help stakeholders understand and act on key data insights
- Develop tools and frameworks to support automated extraction of large volumes of data from websites or other digital sources
- Assist in data governance efforts to ensure data integrity and consistency
- Contribute to internal documentation and provide training to team members on data systems, tools, and best practices
- Work collaboratively with cross-functional team to test and validate new reporting/modeling features
- Effectively display data for decision making
Skills
- Bachelor's degree in Data Science, Analytics, Computer Science, Information Systems, or a related technical field
- 5+ years of professional experience in data engineering or a related field, with a strong track record of building scalable data solutions
- Expert-level proficiency in SQL for data extraction, transformation, and performance tuning
- Hands-on experience with relational databases (e.g., PostgreSQL, SQL Server, MySQL) and building or maintaining enterprise data warehouses
- Familiarity with modern data pipeline tools and orchestration frameworks (e.g., Apache Airflow, dbt, Talend)
- Proficient in data modeling, normalization, and schema design best practices
- Proficiency in Power BI, Tableau, or similar visualization tool
- Proven work history as a Data Engineer
- Advanced proficiency in Excel
- Adept at managing change and fostering innovation in a complex organizational landscape
- Strong analytical and problem-solving skills with the ability to interpret complex data sets and derive actionable insights
- Strong attention to detail and ability to work collaboratively in a cross-functional setting
- This position will need the ability to access US only data systems – US Citizenship is required
- This position is subject to a background check that includes a review of criminal records
- Master's degree or relevant certifications (e.g., AWS, Azure, Google Cloud) are a plus
- Experience working with cloud-based data platforms (e.g., MS Azure) is highly desirable
- Proficiency in scripting languages like Python for data analysis is a plus
- Preferred previous experience with government and/or DoD entities
Benefits
- Medical, Dental and Vision Plan options
- Flexible Spending Accounts, including health and dependent care accounts
- 403B Retirement Savings plan with a very competitive company contribution
- Personal time-off (pre-loaded & accrued) plus 12 paid holiday-days
- Life Insurance paid by ATI
- Paid Parental Leave
- Short-Term & Long-Term Disability Coverage paid by ATI
- Employee Assistance Program
- Tuition Reimbursement Program
- Flexible work schedules
Company Overview