Data Engineer - Support/ SSIS Developer

WHO ARE WE?

Pereview Software is the fastest growing provider of asset and portfolio management software to the global commercial real estate industry. To that end, multiple times since our inception, we have been recognized by Inc. 500, Dallas 100 as a fastest growing privately held business in the United States and have also been recognized by the Dallas Business Journal as one of the top places to work.

Pereview Software is the only life of the asset solution to the commercial investment management industry supporting both debt and equity investments. We serve clients on a global basis from very small investment management managers to some of the largest global firms in the industry.

Would you describe yourself as:

• Methodical
• Visionary
• Factual Communicator

If so, please complete the survey upon applying to the role https://go.cultureindex.com/p/jpWdN1edfuuOn6MKyTV

WHO WE'RE LOOKING FOR?

• Are you a SQL/SSIS developer with a drive for accuracy, quality work, and an innovative mind who want to push through the limits of tech and build something great?
• Do you have the ability to multi-task while exhibiting a sense of urgency by prioritizing appropriately?
• Are you process driven with an appreciation for detail, enjoy working as part of a team or individually with little supervision?
• In this role, being a self-starter in our owner vs. renter culture where everyone is focused on highest and best use of their time and talents toward the strategic goals will bring individual success.
• You should be passionate about your craft, your life, and the impact you can make in a growing organization.
• Developers looking to create and manage ETL solutions that turn data into knowledge.
• You should have a background in data and business analysis. You should be analytical and an excellent communicator.

If you also have a business acumen and problem-solving aptitude, we'd like to meet you. If this role sounds exciting, apply and let's start the conversation!

Requirements

• 3-5 years experience with Microsoft SQL Server Integration Services (SSIS)

• 3-5 years of experience with Microsoft T-SQL

• Client facing experience
• Strong aptitude to learn and grow
• Prior experience with 3rd party interfacing
• Strong experience with relational database concepts
• Requires analytical, conceptual, and problem-solving skills
• Excellent interpersonal skills
• Excellent written and verbal communication skills
• Strong attention to detail, ensuring accuracy and completeness in all tasks and deliverables
• Knowledge of software development life cycle
• Previous experience in commercial real estate financing preferred
• Previous experience with Microsoft report tools (SSRS, Power BI) is a plus
• BS/BA in MIS, Computer Science, Engineering, or relevant field.

Responsibilities :

• Troubleshoot and resolve ETL issues, such as failed job executions or data transformation errors in SSIS packages, ensuring minimal disruption to business operations.
• Create comprehensive documentation for recurring issues and their resolutions to build and maintain a robust knowledge base for the team.
• Engage with clients and internal team members through ticketing systems, emails, and calls, ensuring technical concepts are clearly conveyed to non-technical stakeholders.
• Investigate and resolve data discrepancies in ETL pipelines by performing root cause analysis and proposing effective solutions.
• Identify and escalate issues beyond personal expertise to the appropriate Data Engineer or Senior Data Engineer, providing a clear summary of the investigation and findings.
• Manage and prioritize incoming support tickets, ensuring efficient ticket handling, timely resolutions, and regular updates to stakeholders.
• Dive deeper into ETL requests and client support issues to align technical solutions with business needs, investigating both the symptoms and underlying causes of data issues.
• Tackle challenges in undefined or evolving situations, such as supporting new ETL pipelines with incomplete documentation. Ensure knowledge gaps are addressed by creating or updating Wiki documentation and knowledge bases.
• Actively follow up on unresolved issues, ensuring clients feel supported and their concerns are addressed promptly and effectively.
• Proactively monitor ETL jobs and logs to identify and resolve potential failures before they impact clients, minimizing downtime and service interruptions.
• Provide technical assistance and cross training to other team members.
• Must be able to perform duties with moderate to low supervision.

Benefits

WHAT'S IN IT FOR YOU?

• Competitive salary.
• Competitive Health, Vision, and Dental benefits to fit your needs.
• 401k 4% Company match, 100% vested immediately.

LOCATION

• Only considering candidates who live in Dallas, Texas (DFW) area.
• We are not sponsoring F1, H1B or OPT candidates

Qualification

Bachelor's Degree