Custom Software Systems Inc.
Data Architect
Washington, District of Columbia
No sponsorshipDetected 21 days ago
JavaScriptPythonJavaScalaCSSData StructuresGitSQLNoSQLPostgreSQLAWSAzureCloud PlatformsCI/CDLinuxMachine LearningAirflowData EngineeringAI OrchestrationCybersecurityAccessibilityForecastingProcess ImprovementCustomer Support
About the role
- This role requires a hands-on technical leader with expertise in data modeling, database architecture, ETL/ELT development, cloud technologies, and data governance.
- Participate in the development of future-state data architecture standards, guidelines, and principles.
- Actively participate in process improvement initiatives and in setting best practice standards around Data Architecture, Metadata, Governance, Master Data Management, and Data Quality flows.
Responsibilities
- Analyze data processes, applications, and source data to understand dependencies, anomalies, and implicit business rules that impact the division's ability to manage data.
- Review and analyze existing data models and processes to optimize and modernize current data architectures.
- Design, develop, and maintain robust data pipelines that ingest, transform, and deliver data from multiple sources to analytics platforms, ensuring optimal performance and data integrity throughout the process.
- Architect and implement ETL/ELT workflows using modern data engineering tools and frameworks to support large-scale data processing for economic analysis.
- Create data solution designs for economic policy and research projects, including conceptual models, integration models, and sourcing strategies, in alignment with the division's research needs and data strategy.
- Define specifications and implement database structures, including logical and physical data models, backup and recovery procedures, and access security controls.
- Develop and maintain formal documentation of data structures, data flows, data dictionaries, and technical metadata.
- Collaborate with research and business teams to improve data models and data processes that support analytics and visualization tools, increasing data accessibility and fostering data-driven decision-making across the organization.
- Implement processes and systems to monitor data quality, ensuring production data is accurate, reliable, and available for end users and dependent business processes.
- Identify, design, and implement internal process improvements, including automation of manual processes, optimization of data delivery, and redesign of infrastructure to improve scalability and performance.
Requirements
- Minimum of five (5) years of experience with business intelligence technologies and solutions and leading teams on IT initiatives.
- Minimum of one (1) year of experience with cloud platforms such as AWS and Azure.
- Minimum of two (2) years' experience working in an agile development environment.
- Knowledge, Skills & Abilities
- Experience with workflow orchestration and pipeline automation tools such as Apache Airflow, Prefect, Dagster, or AWS Step Functions.
- Experience migrating workflows and data pipelines between on-premises and cloud environments.
- Experience processing, analyzing, and integrating structured and unstructured data sources.
- Experience performing root cause analysis on internal and external data and business processes to answer business questions and identify opportunities for improvement.
- Strong hands-on software engineering and implementation experience, including development, testing, and deployment of data applications and services.
- .Advanced working knowledge of SQL and experience working with relational database platforms including PostgreSQL, Microsoft SQL Server, and MySQL.
Nice to have
- Understanding of time series data and related analytical and forecasting techniques.
- Experience working in a research environment and/or with economic or financial data.
- Experience with NoSQL and graph database technologies.
- Working experience with cloud technologies such as AWS, Microsoft Azure, and Snowflake.
- Experience implementing data warehouses utilizing Change Data Capture (CDC) methodologies.
- Experience implementing and maintaining CI/CD pipelines and DataOps platforms.
- Working knowledge of additional programming and scripting languages such as Java, Scala, JavaScript, or Perl.
- Wage Range: Negotiable
Compensation
- Wage Range: Negotiable
- Compensation range must be coordinated with and approved by the CSS Chief Operating Officer (COO).
- Compensation & Benefits information is required for all Maryland Employers effective October 1, 2024.
Benefits
- Custom Software Systems, Inc. offers our employees a competitive benefits package that may include:
- Health Savings Account (HSA)
- Basic term life insurance
- Supplemental term life insurance for employees, spouses, and dependents
- Parking/Commuting expense reimbursement
- Compensation & Benefits information is required for all Maryland Employers effective October 1, 2024.
- Health insurance plans
- Long-term disability
- Short-term disability
- Training/Education
Visa & Work Authorization
- Citizenship
Apply directly at Custom Software Systems Inc. →Create a free account for alerts like thisView Custom Software Systems Inc. immigration profile
This listing is sourced directly from Custom Software Systems Inc.'s careers page and normalized into a canonical job model.