Custom Software Systems Inc.
Hybrid Data Architects/Engineer
Custom Software Systems Inc., Baltimore, Maryland, United States, 21276
Custom Software Systems Inc. (CSS) is seeking Hybrid Data Architects/Engineers to join our dynamic team. In this role, you will be responsible for working productively and maintaining effective working relationships with peers, end users, vendor development staff, and all levels of management and Judicial personnel. We are looking for candidates who can critically think and problem-solve, provide excellent communication and mentoring, and quickly evaluate, learn, and prototype new technologies. Additionally, the role involves writing optimized SQL queries, managing databases, and frequently interacting with Azure SQL databases and other SQL-based services.
Responsibilities
Work productively and maintain effective working relationships with peers, end users, vendor development staff, and all levels of management and Judicial personnel.
Critically think and problem-solve.
Provide excellent communication and mentoring needs.
Quickly evaluate, learn, and prototype new technologies.
Write optimized SQL queries and manage databases, as Azure data analysts frequently interact with Azure SQL databases and other SQL-based services.
Required Qualifications
Experience with BI best practices, relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse, and reporting techniques.
Experience with dimensional modeling, STAR schema design, Snowflake schema design, slowly changing dimensions, and confirmed dimensions.
Experience designing and building BI solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, data mapping, monitoring performance, and communicating functional and technical issues.
Experience designing and implementing database models, schemes, and databases to support efficient data storage, retrieval, and analysis.
Experience monitoring and optimizing data systems, data lifecycle, and infrastructure to ensure performance, scalability, and integrity.
Experience designing and implementing ETL procedures for intake of data from multiple source systems; as well as ensure data quality and cleansing is verified.
Experience with the normalization process.
Experience performing the design and extension of data marts, metadata, and data models.
Experience ensuring all data warehouse architecture codes are maintained in a version control system.
Advanced experience with technologies such as SQL Server 2016 or above, as well as with Azure data factory, SSIS, and stored procedures.
Advanced experience developing codes, testing for quality assurance, and administering RDBMS.
High proficiency in dimensional modeling techniques and their applications.
Experience with Azure’s architecture to structure optimized data workflows.
Must have experience with the following tools:
Power BI
Tableau
Azure Synapse
Azure Data Factory
Azure Blob Storage
Azure Databricks
Microsoft Fabric
One Lake
EducationN/A
ClearanceN/A
CitizenshipUS Citizenship
Knowledge, Skills & Abilities
Database and analytical skills.
Ability to query source data.
Knowledge and experience with ETL tools, Visual Studio, and transmitting and reconstructing Extensible Markup Language (XML) and Structured Query Language (SQL).
Knowledge of scripting languages, such as Python, and the ability to automate repetitive tasks in Azure.
Strong analytical, consultative, and communication skills; as well as the ability to make good judgment and work with both technical and business personnel.
Desired QualificationsExample qualification Example qualification Example qualificationExample qualification Example qualification Example qualificationEtc.
Compensation & Benefits
Wage Range: [[$99,999.99 – $99,999.99 per year] or [$99.99 - $99.99 per hour]]
General Benefits: Custom Software Systems, Inc. offers our employees a competitive benefits package that may include:
Health insurance plans
Health Savings Account (HSA)
Dental
Vision
Long-term disability
Short-term disability
Basic term life insurance
Supplemental term life insurance for employees, spouses, and dependents
Simple IRA
#J-18808-Ljbffr
Responsibilities
Work productively and maintain effective working relationships with peers, end users, vendor development staff, and all levels of management and Judicial personnel.
Critically think and problem-solve.
Provide excellent communication and mentoring needs.
Quickly evaluate, learn, and prototype new technologies.
Write optimized SQL queries and manage databases, as Azure data analysts frequently interact with Azure SQL databases and other SQL-based services.
Required Qualifications
Experience with BI best practices, relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse, and reporting techniques.
Experience with dimensional modeling, STAR schema design, Snowflake schema design, slowly changing dimensions, and confirmed dimensions.
Experience designing and building BI solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, data mapping, monitoring performance, and communicating functional and technical issues.
Experience designing and implementing database models, schemes, and databases to support efficient data storage, retrieval, and analysis.
Experience monitoring and optimizing data systems, data lifecycle, and infrastructure to ensure performance, scalability, and integrity.
Experience designing and implementing ETL procedures for intake of data from multiple source systems; as well as ensure data quality and cleansing is verified.
Experience with the normalization process.
Experience performing the design and extension of data marts, metadata, and data models.
Experience ensuring all data warehouse architecture codes are maintained in a version control system.
Advanced experience with technologies such as SQL Server 2016 or above, as well as with Azure data factory, SSIS, and stored procedures.
Advanced experience developing codes, testing for quality assurance, and administering RDBMS.
High proficiency in dimensional modeling techniques and their applications.
Experience with Azure’s architecture to structure optimized data workflows.
Must have experience with the following tools:
Power BI
Tableau
Azure Synapse
Azure Data Factory
Azure Blob Storage
Azure Databricks
Microsoft Fabric
One Lake
EducationN/A
ClearanceN/A
CitizenshipUS Citizenship
Knowledge, Skills & Abilities
Database and analytical skills.
Ability to query source data.
Knowledge and experience with ETL tools, Visual Studio, and transmitting and reconstructing Extensible Markup Language (XML) and Structured Query Language (SQL).
Knowledge of scripting languages, such as Python, and the ability to automate repetitive tasks in Azure.
Strong analytical, consultative, and communication skills; as well as the ability to make good judgment and work with both technical and business personnel.
Desired QualificationsExample qualification Example qualification Example qualificationExample qualification Example qualification Example qualificationEtc.
Compensation & Benefits
Wage Range: [[$99,999.99 – $99,999.99 per year] or [$99.99 - $99.99 per hour]]
General Benefits: Custom Software Systems, Inc. offers our employees a competitive benefits package that may include:
Health insurance plans
Health Savings Account (HSA)
Dental
Vision
Long-term disability
Short-term disability
Basic term life insurance
Supplemental term life insurance for employees, spouses, and dependents
Simple IRA
#J-18808-Ljbffr