Data Architect

We are seeking a technically skilled and solution-focused Data Architect to join our growing Data & Business Intelligence team. In this role, you will design, build, and manage the core data architecture that supports reporting, analytics, and data-driven decision making across the organization.

Working closely with business stakeholders, analysts, and technical teams, you will be responsible for creating scalable and efficient data models, developing robust data pipelines, and enabling effective reporting and analysis through modern cloud data platforms. This position is hands-on and execution-focused, requiring strong technical capabilities in data architecture, data engineering, and business intelligence delivery. Additionally, the role will involve managing and integrating structured and unstructured scientific data found in diverse formats such as relational databases, Excel, Word, PDF, and other data files across the organization, ensuring these data sources are accessible and usable for business and analytical needs.

Application deadline: Our team will begin reviewing applications immediately, and interviews will be scheduled with qualified candidates on a rolling basis. The application process will remain open until we have received a robust pool of qualified candidates. Once we have identified suitable individuals, we may close the application process without prior notice. We appreciate the time and effort invested by all applicants.

• Design, implement, and optimize enterprise data architecture, including data models, pipelines, and transformation processes.

• Develop strategies to manage, integrate, and standardize unstructured scientific data from various sources and formats, ensuring alignment with organizational goals.

• Develop and maintain data integration and transformation pipelines using cloud-based technologies, including Microsoft Fabric components such as Data Factory, Spark Notebooks, Data Engineering, and Data Warehouse.

• Build and optimize data models and datasets to support reporting and self-service analytics using Power BI, including advanced DAX and Power Query techniques.

• Partner with business users and BI developers to gather requirements and deliver data solutions that enable decision-making across departments.

• Define and apply best practices for data governance, data quality, metadata management, and security.

• Monitor and optimize performance, reliability, and scalability of data solutions.

• Maintain clear documentation of data architecture, data models, processes, and standards.

• Stay current with advancements in data architecture and cloud analytics platforms and recommend solutions to improve our data environment.

• Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field, or equivalent experience.

• At least 8 years of experience in data architecture, data engineering, or advanced BI solution development.

• Strong technical expertise in Microsoft modern cloud data platforms, including hands-on experience with Microsoft Fabric components (Data Factory, Spark, Data Engineering, Data Warehouse, Power BI).

• Advanced knowledge of data modeling, ETL/ELT development, and performance optimization.

• Proficiency in Power BI, including advanced DAX, Power Query, and dataset design.

• Understanding of data governance, data privacy, and security best practices.

• Strong analytical and problem-solving skills, with the ability to translate business needs into technical solutions.

• Excellent communication and collaboration skills for working across business and technical teams.

Preferred Qualifications

• Certifications in Microsoft Fabric, Power BI, Azure Data Engineering, or related fields.

• Experience in enterprise data architecture and data pipeline development.

• Familiarity with additional data analysis and transformation languages (SQL, Python, R).

• Knowledge of regulatory and compliance frameworks related to data privacy and security.

SWCA Environmental Consultants is a growing employee-owned firm, providing a full-spectrum of environmental services. Our Vision (the North Star) is to make SWCA the best workplace and industry leader in sustainability, bringing sound science and creative solutions to global environmental challenges while maintaining a dedication to employee-ownership. We live our core values: we collaborate as #OneSWCA; we are #AlwaysLearning, we #NeverSettle, and we #GiveBack.

SWCA Environmental Consultants is a growing employee-owned firm, providing a full spectrum of environmental services. With offices across the United States, SWCA is one of the largest environmental compliance firms and ranks amongEngineering News-Record'sTop 200 Environmental Firms.

If you need assistance accessing SWCA's website, completing the online application, or require accommodations at any point during the hiring process due to a disability, please contact us at accommodations@swca.com or call 1-480-581-5378. We're committed to providing an inclusive and supportive experience for all candidates. This contact information is specifically for accommodation requests; other inquiries will not receive a response.

SWCA is committed to salary equity and salary transparency for all its employees. In alignment with this commitment, SWCA posts good faith pay ranges on all its advertised job postings to promote pay equity and transparency.

An employee in this corporate based position can expect a pay rate of $101,088/year - $132,537/year. Actual pay within this range may depend on experience, qualifications, geographic location, client requirements where applicable, and other factors permitted by law. Regular-status employees are also eligible for performance bonuses. Candidates are also encouraged to consider SWCA's Total Rewards package, which includes a competitive Benefits package, forward-thinking workplace flexibility, outstanding corporate culture, award-winning career development, and more.

EOE - women, minorities, individuals with disabilities and veterans are encouraged to apply. At SWCA Environmental Consultants, we celebrate diversity and are committed to creating an inclusive work environment. We strongly encourage candidates from all backgrounds, including those with diverse experiences and veterans, to apply. We believe that a diverse and inclusive workforce enhances creativity, innovation, and overall organizational success

SWCA continues to invest deeply in career development programs, delivering our award-winning Career Landscape support resources to accelerate the growth of our staff. We recognize the valuable skills and experiences our internal team members bring to SWCA's continued success. Qualified internal candidates are encouraged to apply and will be seriously considered for this position. We believe in promoting from within, where possible, providing our existing employees with compelling opportunities to advance their careers.

#LI-AO1