Sr. Data Analyst - HYBRID

Company and Role:

Dedicated Tech Services, Inc. (DTS) is an award-winning IT consulting firm based in Columbus, OH. We now have an opening for a Sr. Data Analyst.

Highlights and Benefits:

• Hybrid schedule working in Dayton, Ohio.
• Direct W2 hourly or salaried applicants only (no corp-to-corp subcontractors, third parties, or agencies)
• Paid time off and holidays for salaried employees
• 401K, billable bonus, and health, life, vision, dental and short-term disability insurance options for all
• DTS is a proud Women Business Enterprise (WBE) and Woman Owned Small Business (WOSB)!
• Check out our benefits and company information at !

Job Description:

We are hiring an experienced Sr. Data Analyst to work for us as our direct, W2 salaried or hourly employee. You will:

• Have good analytical and communication skills. Have the ability to work independently or with a team, and have a desire to satisfy requirements to create an exceptional customer experience.

Required Skills and Experience:

• 5 years utilizing Data story techniques to present data findings in a clear and accessible manner, catering to both technical and non-technical audiences.
• Contributed to the development of a data-driven culture within the organization by conducting training sessions on data stories and visualization.
• Developed and implemented data stories strategy to communicate complex insights to cross-functional teams and stakeholders.
• Worked on Data stories, data cleaning and preprocessing the data, conducting exploratory data analysis (, and identifying any initial patterns or outliers.
• Worked on Visual elements such as charts, graphs, and other visual representations are essential components of data stories to help make the complex data more accessible and allow audiences to quickly grasp key insights.
• 5 years experience business process modeling and data modeling, database design and development of Web Based, and Client/Server applications.
• Responsible for transforming large amounts of data into compelling visual Data stories to facilitate users.
• Visualized data built presentable dashboards and Data stories in a BI Tool (Tableau, Power BI, OBIEE, etc) and presented it to a team of experts.
• Understand Data warehouse concepts balancing snowflake schema, ETL, Migration of data present in different sources like SQL, Oracle, text, excel, csv etc files into an Integrated MIS Server (Data Warehouse) using ETL tool.
• Proficient in business process modeling, documentation, and testing using Rational Suite (Rational Rose, RequisitePro, SoDA, ClearQuest, Robot) as well as MS Visio and MS Project in combination with UML 2.0 diagramming techniques.
• Data visualization knowledge for Enterprise Reporting Applications such as PBI, Cognos, Tableau, or SSRS.
• In-depth knowledge of creating use case, activity, logical, component and deployment views with rational tools to extract business process flows and workflows thereby helping development and quality assurance teams in understanding the requirements.
• Experience in implementing Slowly Changing Dimensions within MicroStrategy Projects
• Knowledge of ETL (Extract, Transform and Load) processes for bringing data into a data warehouse/date mart and Business Intelligence (BI) tools
• Experience in Jira, Confluence, Version One and Business Process Management (BPM) or Primavera for Enterprise Project Portfolio Management tool.
• Hands on experience with JIRA Agile and Confluence management and collaboration tools.
• Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.
• Experience in working to gather requirements for an EDW: e.g., Hadoop Big Data Environment, Netezza, Snowflake, Azure, Databricks
• Experience in designing, developing and maintaining Kimball's Method Data warehouse system
• Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures.
• Able to perform Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements
• Strong oral and exceptional written business communication skills
• Good understanding of Enterprise Data Warehouse insight data.
• Excellent meetings facilitator with excellent inter-personal and conflict resolving skills.
• Hardware and software knowledge: ETL tools (DataStage Informatica), Data Catalog Tools (Alation, Informatica) Star-Schema Modeling, Snowflake Modeling, FACT and dimension tables, Erwin 4.0, PowerBI, Business Objects, Tableau, Cognos, MicroStrategy, Oracle SQL, MySQL, Visio, Mural, MS Office

Those authorized to work in the US are encouraged to apply. We are unable to sponsor at this time.

Dedicated Tech Services, Inc. is an Equal Opportunity Employer