Senior Data Analyst

Summary

Join Trace3, a leading Transformative IT Authority, as a Data Analyst and provide technical consulting support to clients. You will participate in marketing and pre-sales efforts, create reports and dashboards using tools like Tableau and Power BI, develop semantic models, write DAX and SQL queries, and design scalable data warehousing solutions. Leverage tools like R, Python, and Hadoop for efficient analytics, and establish strong relationships with clients. Develop complex reporting and analysis to provide leadership transparency, lead cross-functional team training, and travel up to 20% domestically. This position requires a Master's degree or equivalent in a related field with 3 years of experience or a Bachelor's degree with 5 years of experience, along with 3 years of experience with SQL and reporting tools.

Requirements

• Master’s degree or foreign equivalent in Information Systems, Computer Science, or a closely related field plus three (3) years of experience as a Data Analyst, or closely related business intelligence role
• Employer will also accept a Bachelor’s degree or foreign equivalent in Information Systems, Computer Science, or a closely related field plus five (5) years of progressive experience as a Data Analyst, or closely related business intelligence role
• Three (3) years of experience with querying data using SQL or other query and scripting languages to aggregate, gather, and manipulate data
• Three (3) years of experience using reporting and dashboarding tools including Tableau
• Travel: Up to 20% domestic travel for client and business review meetings, and occasional onsite training

Responsibilities

• Provides technical consulting support to clients in the areas of dashboard/report development, data preparation, and supporting requirements gathering
• Participates in marketing and pre-sales efforts to win projects and build client relationships
• Creates reports and dashboards using data visualization and reporting tools such as Tableau and Power Business Intelligence (BI)
• Develops and optimizes semantic models in analysis services tabular models and Power BI models with complex business logic
• Writes Data Analysis Expressions (DAX) to build business calculations for reporting and dashboard use
• Develops and maintains data pipelines using Azure native services like Azure Data Factory, Synapse, Spark, Python, Databricks
• Writes advanced SQL using Presto/Hive including structured, complex, and efficient queries on large data sets and to optimize queries
• Designs and develops scalable data warehousing solutions, building Extract, Transform, Load (ETL) pipelines in Big Data environments (cloud, on-premises, hybrid)
• Leverages tools like R, Python, Hadoop & SQL to drive efficient analytics
• Establishes strong relationships with key stakeholders and decision makers in client organizations
• Develops complex reporting and analysis to provide leadership transparency to vendor, contract, and risk management priorities; providing recommendations to achieve cost savings and vendor risk management goals
• Leads cross functional/teams training to incorporate new methodology and streamline existing business processes and assists in creation of new business processes
• Position is for roving employee who will work in various unanticipated locations throughout the U.S. according to business need

Preferred Qualifications

• Experience in Statistical Analysis packages such as R, SAS or MATLAB
• Experience in data mining and ETL and using databases in a business environment with large-scale, complex datasets
• Experience using Cloud Storage and Computing technologies such as AWS Redshift, S3, and Hadoop
• Experience designing and developing Power Platform applications
• Experience developing and integrating Power Apps, Canvas App, Model Driven Apps, Power Pages, Power Automate, Power BI, Report Builder, Dataverse, SQL Server Database, Azure Active Directory, and Microsoft Teams
• Experience serving as a Power Platform subject matter expert and providing knowledge transfer to the developers
• Experience developing Power Pages to create an external website or application
• Experience developing Power Automate flow for several approval processes/components of the Project Tracking Console
• Experience with design and Architecture in D365 and Power Platform solutions using Model Driven Apps, Dataverse, Cloud Flows, and Power BI
• Hands-on experience working with multiple data sources including Dataverse (CDS), SQL/Azure SQL, SharePoint, and other connectors
• Experience with Power Automate Desktop RPA, AI Builder technologies, PowerApps integration with Azure API Apps and REST services, Power Pages, Power Virtual Agents and its customization and deployment, Dynamics 365 customizations

Benefits

• Comprehensive medical, dental and vision plans for you and your dependents
• 401(k) Retirement Plan with Employer Match, 529 College Savings Plan, Health Savings Account, Life Insurance, and Long-Term Disability
• Competitive Compensation
• Training and development programs
• Stocked kitchen with snacks and beverages
• Collaborative and cool culture
• Work-life balance and generous paid time off