Location: Tallahassee, FL
Company: Signature Consultants
data dictionaries, data flow, interdependencies, and potential problem areas.
Design, develop, and implement a new Microsoft SQL Server data warehouse, ensuring it meets the project requirements and aligns with the overall data strategy of the Department (the Department is under a " cloud first" initiative, and the new data warehouse is preferred to reside in the Azure cloud).
Develop and maintain ETL processes to migrate data from the new State's accounting system, Florida PALM to the new SQL Server data warehouse. Implement data modeling and design techniques to build scalable and efficient data structures to meet the Department's accounting and budgeting reporting
needs. Design and create data dashboards, visualizations, and reports using Power BI, providing critical insights to stakeholders. Troubleshoot any issues that arise in the data warehouse and implement solutions.
Collaborate with other team members, stakeholders, and data users to ensure the new data warehouse meets the needs of the Department. Continuously monitor, refine, and report on the performance and capacity of the data warehouse. Configure and administer data warehouse security settings, working closely with the Information Security team to ensure the best practices are in place. Stay up to date on new data warehousing technologies and approaches. Train and mentor less
experienced team members. Coordinate with other IT teams to ensure smooth data warehouse operations.
Handle incident management and problem resolution for data warehouse issues. Develop data mining models to identify trends and patterns within large datasets. Ensure that data is accurate and clean, using statistical methods such as data profiling and data quality analysis to identify potential problems with data quality before using it in reports or analyses. Develop and thoroughly documenting the processes and procedures for the warehouse's day-to-day operations, including creating backup plans for disaster recovery in case of equipment failure or data loss.
Design and implementing data warehouse solutions that meet the Department's needs while ensuring compliance with industry regulations regarding the security of sensitive data. Work collaboratively with stakeholder teams to compile audience profiles, insights, and measurement plans. Create simple, easy-to-follow reports and dashboards that key department heads will utilize on a regular basis to make informed business decisions. Work with multiple Project Managers to deliver capabilities/projects/data sets/reports that have been prioritized by the Business Product Owners. Work with the Manager of the Department's Research & Data Team and other stakeholders to accurately integrate collected data into the data warehouse, using descriptive analytics to research and perform statistical analysis to identify actionable insights.
Ensure that reporting and key institutional metrics are regularly updated, available, and accurate. Provide expertise to the Data Governance team. Create ad-hoc reports as needed. Stay current of technology and best practices. Regularly attend training and proactively conducts research when available. Oversee the work of several other individuals and must be able to motivate team members, delegate tasks, perform knowledge transfers, and mentor staff.
Must be able to handle all duties and information in a confidential manner. Must have the ability to simplify information systems and make sound business decisions. Required Experience: Seven (7) or more years of experience in a BI, Data Engineer, or ETL role. Proven experience working with SQL databases and Microsoft SQL Server. Proven track record of successful data warehouse implementations. Proven experience in data warehouse design and development. Proven experience in ETL tools, processes, and in data migration projects.
Proficient understanding of data warehousing methodologies. Proven proficiency with Microsoft Power BI for creating dashboards and reports. Proven experience with data modeling, data architecture, and data quality concepts. Proven proficiency in SQL and other data languages. Excellent troubleshooting and problem-solving abilities. Capable of explaining complex concepts to non-technical stakeholders. Must be able to clearly convey information and ideas in both written and verbal forms to share. information, share ideas, and resolve issues.
Ability to communicate and interact professionally and tactfully with people of different levels of education, cultural backgrounds, and life experiences and to exhibit respect to others; and Strong organizational skills and attention to detail, including the ability to adequately establish timeframes and deadlines, meet deadlines, and follow through on tasks and assignments. Preferred Experience: Experience working in the corrections or public safety sector. Experience working with financial systems. Previous involvement in public sector IT projects. Experience working with large datasets and data lakes.
Experience with other data visualization tools. Familiarity with Databricks SQL. Experience with big data technologies. Familiarity with Machine Learning and Artificial Intelligence concepts and their application in data analysis. Experience in implementing ML and AI solutions in data warehouse environments. Experience with security technologies around cloud solutions, preferably Azure. Experience managing projects using Scrum and Kanban. Preferred Licensing or Certifications, such as Association for Supply Chain Management (ASCM) Warehousing Certification; Data Warehousing and BI Certification Training; Data Warehousing for Business Intelligence Specialization; BI Foundations with SQL, ETL, and Data Warehousing Specialization, and Enterprise Data Management.
Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U. S. Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.
Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit / to learn more. Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, interaction, interactionual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.
IT jobs refer to positions within the Information Technology sector, where professionals focus on computer-based systems. These roles can range from software development, network administration, and cybersecurity to data analysis and IT support. IT jobs often feature continuous learning due to the fast-paced nature of tech advancements. Additionally, they may offer flexibility with options for remote work and have a significant emphasis on problem-solving and innovation. As technology becomes increasingly integral to all industries, IT jobs are in high demand and often offer competitive salaries.
IT jobs refer to positions within the Information Technology sector, which encompasses a broad range of roles focused on the development, implementation, and maintenance of technology systems. These positions often require skills in programming, network administration, cybersecurity, and data analysis. IT professionals work with computer hardware, software applications, and algorithms. Key characteristics of IT jobs include a focus on problem-solving, continuous learning to keep up with technological advancements, and the ability to adapt to the evolving digital landscape. Many IT roles also support remote work, given the digital nature of the tasks.
IT jobs refer to employment within the field of information technology, an industry centered on the creation, maintenance, and support of computer systems and networks. Characteristically, these roles demand technical expertise in areas such as software development, cybersecurity, and data analysis. IT professionals are typically required to quickly adapt to new technologies and solve complex problems, often working in dynamic, fast-paced environments. The sector is known for its diverse career opportunities and has become essential across virtually all business sectors, reflecting the critical role technology plays in modern society.
IT jobs refer to employment within the field of information technology, an industry centered on the creation, maintenance, and support of computer systems and networks. Characteristically, these roles demand technical expertise in areas such as software development, cybersecurity, and data analysis. IT professionals are typically required to quickly adapt to new technologies and solve complex problems, often working in dynamic, fast-paced environments. The sector is known for its diverse career opportunities and has become essential across virtually all business sectors, reflecting the critical role technology plays in modern society.
