Software/Data Engineer

Company: Clientsolv Inc.
Location: Aurora
Posted on: January 12, 2022

Job Description:

Company Description

ClientSolv Technologies is an IT solution firm with over a decade of experience serving Fortune 1000 companies, public sector and small to medium sized companies. ClientSolv Technologies is a woman-owned and operated company that is certified as a WMBE, 8a firm by the Federal government's Small Business Administration.

Job Description

We are seeking a Software/Data Engineer for a direct hire/permanent role in Englewood, CO. This role will be work a hybrid schedule with varying in office and remote work days each week (typically 3-4 days remote and 1-2 days onsite) in the Englewood area and will be joining a growing Enterprise Data and Software Engineering Team! In this role, you will be responsible for Object Oriented Programming (OOP) and developing design patterns in an effort to maintain high-quality data models, data infrastructure, and data science capabilities. Additional responsibilities include:

• Design, develop, and maintain .Net Core console and web apps by writing testable, reusable, and efficient code
• Build tabular models in SQL Server Analysis Services (SSAS) to be consumed by business analysts
• Work closely with the Business Analytics team to implement, deploy, and maintain PowerBI datasets, reports, and dashboards
• Write SQL stored procedures to deliver ad-hoc data requests and present results in a clear manner such as Excel, csv files, PowerBI, and SSRS reports
• Build relevant ETL pipelines in the data warehouse using SQL Server stored procedures or SQL Server Integration Services (SSIS)
• Process, clean, and verify the integrity of data used for analysis
• Explore and implement modern data warehouse technologies
• Create maintainable projects with documentation using Bitbucket, JIRA and Confluence
• Participate in rotating on call schedule to support infrastructure Qualifications
  
  • 5+ years of experience with C#, focus on backend development, ideally .NET Core 3.1+
  • Fluency in Python with working knowledge of interacting with SQL, pandas and numpy
  • Understands and has practiced agile software development
  • 5+ years SQL experience building complex SQL queries and stored procedures
  • Solid experience creating self-service content within Power BI or similar BI tools
  • Possess strong knowledge of REST/SOAP APIs and ADO
  • Experience building tabular data models with SQL Server Analysis Service or similar tools
  • Knowledge of core data warehouse concepts such as ETL, dimensional modeling
  • AWS experience with S3, SNS, Lambda, RDS, ECS, CodeBuild, and CodeDeploy
  • Comfortable using source control systems and their associated ecosystems, e.g., Git and Github/Bitbucket
  • BS in Computer Science/ Information Technology OR 7+ years of relative experience
    Nice To Have
    
    • Experience using the full suite of Microsoft BI tools (SSRS, SSIS, SSAS) is a plus
    • Experience with a cloud-based data warehouse and architecture (e.g. Snowflake, Amazon Redshift, etc.) is a plus
    • Proficiency with professional software engineering practices; including coding standards, code reviews, source control management, build processes, testing, and operations is a plus
      Additional Information
      
      This direct hire/permanent role will be located in Englewood, CO. This role will offer a salary range between $100,000- $130,000 per year and a comprehensive benefit package to include insurance (medical, dental, vision, pet, etc.), gym reimbursement, matching 401k with immediate vesting, and flexible time off options. This will be a hybrid schedule with varying in office and remote work days each week (typically 3-4 days remote and 1-2 days onsite)by Jobble

Keywords: Clientsolv Inc., Aurora , Software/Data Engineer, IT / Software / Systems , Aurora, Colorado