Hauppauge
Job Description SmartSource®, an ABCOM Technology Group company, has more than 35 years of experience serving clients' business technology needs in the events, staffing, legal, government, finance, education, entertainment, and meeting production industries. The company provides service throughout North America through its fully staffed and equipped offices in major metropolitan markets. SmartSource draws from its extensive inventory of IT, AV, and interactive technologies to deliver solutions as varied as computers for contract staff, office equipment for temporary spaces, or multi-story video walls for trade shows and events. The SmartSource team is passionate about leveraging its expertise to empower clients to excel. SmartSource will afford you an exciting career opportunity. We offer a fast-paced and dynamic work environment. Most importantly, you will be provided the support and environment to excel and succeed with an industry leading company. If you are enthusiastic, highly motivated and looking for a great opportunity, we encourage you to apply today. Job Summary: The Data Manager is responsible for overseeing the organization’s data systems, ensuring the integrity, security, and accessibility of business data across multiple platforms. This role requires expert-level skills in SQL, IBM Cognos Analytics, and Microsoft Power BI to support enterprise reporting, analytics, and decision-making processes. The Data Manager will collaborate closely with IT, finance, operations, and executive teams to deliver trusted, actionable insights. Responsibilities: Data Architecture & Management • Design, implement, and maintain enterprise data models, ETL processes, and data governance standards., • Ensure high data quality, consistency, and integrity across systems., • Write and optimize complex SQL queries, stored procedures, and views., • Support data warehouse and data mart development using advanced SQL Server or similar platforms., • Develop, maintain, and optimize dashboards and reports in IBM Cognos Analytics and Power BI., • Translate business requirements into efficient and visually effective analytical solutions., • Partner with business stakeholders to define KPIs, metrics, and data strategies., • Provide training and technical guidance to analysts and report developers., • Enforce data governance best practices, including documentation, naming conventions, and version control. Education & Experience: • Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field (Master’s preferred)., • 5+ years of professional experience in data management, business intelligence, or database administration., • Proven expertise in SQL (T-SQL or PL/SQL), IBM Cognos Analytics, and Microsoft Power BI., • Experience managing or supporting data warehouse environments (Microsoft SQL Server, Azure, Snowflake, etc.)., • SQL Server, SSIS, or equivalent ETL platforms., • Cognos Framework Manager and Report Studio., • Power BI Desktop, Power BI Service, DAX, Power Query (M)., • Excellent communication and documentation abilities., • Strong analytical and problem-solving skills., • Microsoft Certified: Data Analyst Associate (Power BI), • IBM Cognos Analytics Author/Administrator Certification, • Microsoft Certified: SQL Database Administrator or Data Engineer SmartSource is an equal opportunity/affirmative action employer. SmartSource does not discriminate on the basis of race, color, religion, gender (including non-binary/third gender), transgender, gender identity or expression, sexual orientation or affectional preference, national origin, citizenship, age, disability, status as a protected veteran, military status, marital status, or status in any group or class protected by applicable federal, state, or local law. SmartSource makes reasonable accommodations for qualified individuals with disabilities in accordance with the Americans with Disabilities Act, Rehabilitation Act, and applicable state and local laws.