What are the responsibilities and job description for the Data Solution Architect position at PDS Defense, Inc.?
PDS Defense is looking for a Contract Data Solution Architect to join the Airplane Systems Integration team in Everett WA
This is a fully ONSITE Contract position
Contract Duration 12 months
Pay 96.00 per hour
Position Responsibilities:
• Designs, develops, and maintains ETL routines and reporting using Microsoft SQL Server and Power BI.
• Identifies and recommends changes to optimize the ETL environment, implement monitoring, quality and validation processes to ensure data accuracy and integrity.
• Conducts or coordinates unit and system tests ensuring intelligence is consistent with defined needs.
• Designs and deploys database table structures, reports, and queries.
• Supports implemented BI solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance, and communicating functional and technical issues.
• Conducts comparison processes to identify and develop process improvements; provides recommendations on next steps and manages deliverables.
• Documents specifications for Data Warehouse (DWH) extracts, reports, dashboards, or other outputs.
• Facilitates and leads project planning and execution with cross functional teams across the organization.
• Design, develop, maintain, and optimize current AP Systems Reporting infrastructure systems (Including on Prem SQL Db, data warehouses, and cloud lake house)
• Guides other data and analytics professionals on data standards and practices
• Work closely with AP Systems business intelligence experts to ensure data product attributes accurately represent business process outputs to drive actionable reporting and modeling insights.
• Build repeatable data pipeline strategy across multi environments, leverage automation to make sure ETL solutions are repeatable and scalable
Required Skills:
• Minimum of 5 years of relevant experience in developing data warehousing solutions, dashboards, scorecards, and analytics.
• Proficient in writing T-SQL code, SSIS packages, and Stored Procedures on Microsoft SQL Server.
• Strong knowledge of data integration and ETL processes, with experience in designing and implementing efficient data pipelines.
• Proficiency in system architecture design, including selecting appropriate database technologies, data warehousing solutions, and distributed computing frameworks.
• Familiarity with AI concepts and algorithms, with the ability to collaborate with data scientists in implementing AI models and integrating them into data systems.
• Strong problem-solving and troubleshooting skills, with the ability to monitor and optimize the performance of data systems, ensuring data quality, integrity, and security.
• Proficient in writing Rest API/mTLS to extract data from various physical and cloud databases/data lakes.
• Experience in Data Visualization / UX Designer skills - designs user flows and interfaces for data-driven applications and dashboards.
Preferred Skills:
• Bachelor’s degree in mathematics, Computer Science, or a related field.
• 10-15 years data engineering experience and transforming internal businesses through automation and other technologies.
• Aviation Industry Experience Strongly Preferred.